﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Agresso.Interface.Layer.SQL
{
    public class BunkerInventoryManagerMappingSQL
    {
        public static string Insert()
        {
            return @"
            INSERT INTO [i_BunkerInventoryManagerMapping]
           ([profit_centre_fullname]
           ,[client]
           ,[description]
           ,[dim_value]
           ,[rel_value]
           ,[client_map]
           ,[description_map]
           ,[dim_value_map]
           ,[rel_value_map])
     VALUES
           (@profit_centre_fullname
           ,@client
           ,@description
           ,@dim_value
           ,@rel_value
           ,@client_map
           ,@description_map
           ,@dim_value_map
           ,@rel_value_map)";
        }

        public static string Update()
        {
            return @"
            update [i_BunkerInventoryManagerMapping] set
            [profit_centre_fullname] = @profit_centre_fullname
           ,[client] = @client
           ,[description]= @description
           ,[dim_value]= @dim_value
           ,[rel_value]= @rel_value
           ,[client_map]= @client_map
           ,[description_map]= @description_map
           ,[dim_value_map]= @dim_value_map
           ,[rel_value_map]= @rel_value_map
            where
           BunkerInventoryManagerMappingID = @BunkerInventoryManagerMappingID ";
        }

        public static string MaxID()
        {
            return "select max(BunkerInventoryManagerMappingID) from i_BunkerInventoryManagerMapping";
        }
        public static string FIndByProfitCentre()
        {
            return "select * from i_BunkerInventoryManagerMapping where profit_centre_fullname=@profit_centre_fullname";
        }
        public static string FindByDimValue()
        {
            return "select * from i_BunkerInventoryManagerMapping where dim_value=@dim_value";
        }

        public static string GetAllMapping()
        {
            return "select * from i_BunkerInventoryManagerMapping";
        }
    }
}
